﻿<?xml version="1.0" encoding="utf-8"?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobjlist of eComCheckoutWizardStep">
	<Sql>
		SELECT        eComPreCheckoutWizardSteps.id, eComPreCheckoutWizardSteps.viewName, eComPreCheckoutWizardSteps.productId AS product_id,
		eComPreCheckoutWizardSteps.completeOption, eComPreCheckoutWizardSteps.orderIndex AS [index],
		Articles.baseTitle, Articles.summary, Articles.primaryMediaName, Articles.translatedTitles,
		Articles.translatedSummaries
		FROM            eComPreCheckoutWizardSteps LEFT OUTER JOIN
		Articles ON eComPreCheckoutWizardSteps.id = Articles.id
		WHERE        (eComPreCheckoutWizardSteps.companyId = @companyId)
		ORDER BY orderIndex
	</Sql>
	<Param name="companyId" type="UniqueIdentifier"/>
</AdoNetDataAccess>
